338 alter 339 add 342 create proc 350 set implicit_transactions on 351 set implicit_transactions off 352 as 353 null 354 select 355 where 359 SET ROWCOUNT 360 SET NO_BROWSETABLE 361 BEGIN TRAN 362 SET TEXTSIZE 363 bit 364 tinyint 365 bigint 366 image 367 varbinary 368 binary 369 text 371 char 372 numeric 373 decimal 374 int 375 smallint 376 float 377 real 378 double 379 date 380 time 381 datetime 382 varchar 383 timestamp 384 sysname 385 smallmoney 386 smalldatetime 387 money 388 drop proc 389 use 391 insert 392 delete 393 update 394 from 395 holdlock 396 where 1=2 397 create;drop;select;grant;revoke;alter;truncate;update;reconfigure;load;disk; 398 statistics 401 'yyyymmdd' 402 'hh:mm:ss' 403 'yyyymmdd hh:mm:ss.000' 411 EXEC 413 IF @@TRANCOUNT > 0 COMMIT TRAN 414 IF @@TRANCOUNT > 0 ROLLBACK TRAN 415 select USER_NAME() select usertype,type,name from systypes where usertype>=100 416 dbcc traceon(208) 417 set quoted_identifier 418 set ansi_nulls off set ansi_padding off set ansi_warnings off 419 select usertype,type,name from systypes where usertype>=100 select 502,NULL,USER_NAME() exec sp_server_info 1 exec sp_server_info 2 exec sp_server_info 500 select 501,NULL,1 where 'a'='A' set textsize 2147483647 set arithabort on 420 select usertype,type,name from systypes where usertype>=100 select 502,NULL,USER_NAME() exec sp_server_info 500 select 501,NULL,1 where 'a'='A' set textsize 2147483647 set ansi_null_dflt_on on set arithabort on 421 select usertype,type,name from systypes where usertype>=100 select 502,'',USER_NAME() exec sp_server_info 500 select 501,'',1 where 'a'='A' set textsize 2147483647 set ansi_defaults on set cursor_close_on_commit off 422 begin declare @n varchar(30) exec sp_fallback_MS_sel_fb_svr @n output select 503,'',@n end 423 table 424 %04d-%02u-%02u %02u:%02u:%02u.%03lu 438 create 439 drop 440 SET PARSEONLY ON 441 SET PARSEONLY OFF 442 SET NOEXEC ON 443 SET NOEXEC OFF 458 '%04d%02u%02u %02u:%02u:%02u.%03lu' 459 select 'us_english' union select name from master..syslanguages 461 select name from master..sysdatabases 462 set language 464 select ISNULL(language,'us_english') from master..syslogins where suid=SUSER_ID() 466 select dbname from master..syslogins where suid=SUSER_ID() 472 'SYSTEM TABLE' 473 'TABLE' 474 'VIEW' 478 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 479 SET TRANSACTION ISOLATION LEVEL READ COMMITTED 481 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ 483 identity 484 , 485 SET TRANSACTION ISOLATION LEVEL SERIALIZABLE 486 char binary decimal integer smallint float real double varchar date time timestamp longvarchar varbinary longvarbinary tinyint bit numeric 487 char(255);binary(255);decimal(38,4);int; smallint;float;real;float; varchar(255);datetime;datetime;datetime; text; varbinary(255);image; tinyint;bit;numeric(38,4); 488 char(255);binary(255);money; int; smallint;float;real;float; varchar ;datetime;datetime;datetime; text; varbinary ;image; tinyint;bit; 510 AVG 511 CNT 512 MAX 513 MIN 514 SUM 515 order 516 SET FMTONLY ON 517 SET FMTONLY OFF 540 BREAK,BROWSE,BULK,CHECKPOINT,CLUSTERED,COMMITTED,COMPUTE,CONFIRM,CONTROLROW,DATABASE,DBCC,DISK,DISTRIBUTED,DUMMY,DUMP,ERRLVL,ERROREXIT,EXIT,FILE,FILLFACTOR,FLOPPY,HOLDLOCK,IDENTITY_INSERT,IDENTITYCOL,IF,KILL,LINENO,LOAD,MIRROREXIT, 541 NONCLUSTERED,OFF,OFFSETS,ONCE,OVER,PERM,PERMANENT,PLAN,PRINT,PROC,PROCESSEXIT,RAISERROR,READ,READTEXT,RECONFIGURE,REPEATABLE,RETURN,ROWCOUNT,RULE,SAVE,SERIALIZABLE,SETUSER,SHUTDOWN,STATISTICS, 542 TAPE,TEMP,TEXTSIZE,TRAN,TRIGGER,TRUNCATE,TSEQUEL,UNCOMMITTED,UPDATETEXT,USE,WAITFOR,WHILE,WRITETEXT 600 ConnectionObjectSize 601 ConnectionRead 602 ConnectionWrite 603 ConnectionTransact 604 ConnectionWriteOOB 607 ConnectionOpen 608 ConnectionClose 609 ConnectionCheckForData 613 ConnectionError 1106 SQLSRV32.DLL 1125 select substring('NY',status/1024&1+1,1) from master..sysdatabases where name=DB_NAME() 1177 02.50 1194 select c.definition from master.dbo.syscharsets c,master.dbo.syscharsets c1,master.dbo.sysconfigures f where f.config in(123,1123)and f.value=c1.id and c1.csid=c.id 10110 21S0121S01 10111 21S0121S01 10121 0700807008 10122 0700807008 10169 2200322003 10207 2200522018 10208 S002242S22 10209 S000242S02 10211 2200822007 10212 2200822007 10214 21S0121S01 10221 2200322003 10222 2300023000 10230 4200042000 10231 4200042000 10233 2200322003 10234 2300023000 10235 2200322003 10236 2200522018 10237 2200322003 10238 2200322003 10239 2200322003 10240 S000242S02 10241 2200322003 10242 2200822007 10243 2200822007 10245 2200322003 10246 2200522018 10247 2200322003 10248 2200522018 10249 2200322003 10250 2200522018 10257 2200522018 10267 2500025000 10268 S000242S02 10273 2300023000 10274 2300023000 10278 2500025000 10296 2200822007 10297 2200822007 10306 2200522018 10311 2202522025 10410 2200522018 10513 2100021000 10516 2300023000 10518 2200822007 10519 2200522018 10520 2200322003 10521 2200322003 10522 2200322003 10523 2200322003 10524 2200322003 10525 2200322003 10530 2200522018 10531 2300023000 10536 2200322003 10548 2300023000 10551 4400044000 10612 2500025000 10629 2500025000 10912 0800408004 10917 0800408004 10920 0100001000 10927 0100001000 11008 2200322003 11011 2201922019 11206 4000140001 11212 4000140001 11506 2300023000 11509 2300023000 11907 S000242S02 11912 S002242S22 11914 S001142S11 12502 S000242S02 12602 2300023000 12616 2300023000 12626 4000140001 12627 2300023000 12628 2300023000 12706 S002142S21 12707 S000242S02 12715 S000142S01 12728 S002142S21 12729 S000242S02 12741 0800408004 13002 S001242S12 13310 4000140001 13605 2300023000 13606 2300023000 13607 0100001000 13608 0100001000 13623 0100001000 13702 S000242S02 13704 S001242S12 13719 S001242S12 13903 2500025000 13904 2500025000 13907 2500025000 13909 2500025000 14003 2800028000 14018 0800408004 14314 S001242S12 14315 S000242S02 14402 S000242S02 14410 21S0221S02 14502 21S0221S02 14503 21S0221S02 14507 S002142S21 14510 S002142S21 14702 S000242S02 14903 S000242S02 15702 0100001000 15704 0100001000 16227 S001242S12 16402 2500025000 17113 4000140001 18116 2200322003 18135 2201222012 18153 2200122001 18154 0100301003 26903 S1109HY109 26917 3400034000 26930 S1009HY009 26931 2400024000 26932 2400024000 26935 01S0301001 27810 0800408004 28451 0800408004 28459 0800408004 28460 2800028000 40000 Cannot drop the index 40001 SQL Server Login 40002 table 40003 owner 40004 database 40005 stored procedure 40006 (local) 40007 The server name also exists in the registry and may be needed by other SQL Server applications.\n\nChoose Yes to remove the name from the registry, No to leave the registry unchanged. 40008 ODBC SQL Server Setup 40009 %s cannot be used as a data source name. 40011 Help is not available 40012 (Default);us_english;français;deutsch; 40013 %s is already a data source name.\nOverwrite? 40014 Invalid character in data source name. 40015 %s is not an existing data source name. 40016 Do you want to convert your SQL Server 16 bit DSNs to 32 bit? 40017 Filling listbox requires a valid Login Id and Password 40018 Filling listbox failed:\nSQLState: '%s'\n SQL Server Error: %ld\n%s 40019 Connection failed:\nSQLState: '%s'\nSQL Server Error: %ld\n%s\n 40020 &Server: 40021 (Default) 40022 Unknown Translator 40023 Select Log File 40024 Log Files(*.log)|*.log|All Files(*.*)|*.*| 40025 Query Logging Threshold field must be numeric 40026 At %s the following query executed in %lu milliseconds 40100 0100001000General warning 40101 0100001000Ongoing transaction has been committed 40102 0100001000The ODBC catalog stored procedures installed on server %s are version %s; version %02d.%02d.%4.4d or later is required to ensure proper operation. Please contact your system administrator. 40103 0100001000Access to database configured in the DSN has been denied. Default used. 40104 0100001000Language configured in the DSN is not supported. Default used. 40105 0100001000Procedure executed with 'EXEC'. No output parameters returned. 40106 0100401004Data truncated 40107 01S0001S00Invalid connection string attribute 40108 01S0101S01Error in row 40109 01S0201S02Option value changed 40110 01S0201S02Packet size change not honored by server, server size used 40111 01S0301001No rows updated or deleted 40112 01S0501S05Cancel treated as FreeStmt/Close 40113 01S0601S06Attempt to fetch before the result returned the first rowset 40114 0700107001Wrong number of parameters 40115 0700607006Restricted data type attribute violation 40116 07S0107S01Invalid use of default parameter 40117 0800108001Unable to connect to data source 40118 0800408004Data source rejected establishment of connection 40119 08S0108S01Communication link failure 40120 21S0121S01Insert value list does not match column list 40121 21S0221S02Degree of derived table does not match column list 40122 2200122001String data right truncation 40123 2200222002Indicator variable required but not supplied 40124 2200322003Numeric value out of range 40125 2200522018Error in assignment 40126 2200822007Invalid date 40127 2200822007Invalid time 40128 2200822007Invalid timestamp 40129 2202622026String data, length mismatch 40130 2400024000Invalid cursor state 40131 2500025000Invalid transaction state 40132 2800028000Invalid authorization specification 40133 2800028000Invalid authorization specification; Access to selected database has been denied 40134 2800028000Invalid authorization specification; Language specified is not supported 40135 3400034000Invalid cursor name 40136 3700037000Syntax error or access violation 40137 3C0003C000Duplicate cursor name 40138 7010070100Operation aborted 40139 IM001IM001Driver does not support this function 40140 IM006IM006Packet size change not supported by server, default used 40141 IM008IM008Dialog failed 40142 IM009IM009Unable to load translation DLL 40143 IM009IM009Translation module is not valid 40144 S1000HY000General error 40146 S1000HY000The stored procedure required to complete this operation could not be found on the server (they were supplied with the ODBC setup disk for the SQL Server driver). Please contact your system administrator. 40147 S1000HY000Unknown token received from SQL Server 40148 S1000HY000Operation not allowed while results are pending 40149 S1000HY000Unable to load communication module. Driver has not been correctly installed. 40150 S1000HY000Communication module is not valid. Driver has not been correctly installed. 40151 S1000HY000Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed. 40152 S1000HY000Connection is busy with results for another hstmt 40153 S1000HY000Failure during closing of connection 40154 S1000HY000Protocol error in TDS stream 40155 S1000HY000TDS buffer length too large 40156 S1000HY000Non-default parameter not allowed after default parameter 40157 S1001HY001Memory allocation failure 40158 S100207009Invalid column number 40159 S1003HY003Program type out of range 40160 S1008HY008Operation canceled 40161 S1009HY009Invalid argument value 40162 S1010HY010Function sequence error 40163 S1011HY011Operation invalid at this time 40164 S1015HY015No cursor name available 40165 S1090HY090Invalid string or buffer length 40166 S1091HY091Descriptor type out of range 40167 S1092HY092Option type out of range 40168 S1093HY021Invalid parameter number 40169 S1021HY021Inconsistent descriptor information 40170 S1094HY021Invalid scale value 40171 S1096HY096Information type out of range 40172 S1104HY104Invalid precision value 40173 S1105HY105Invalid parameter type 40174 S1106HY106Fetch type out of range 40175 S1107HY107Row value out of range 40176 S1109HY109Invalid cursor position 40177 S1111HY111Invalid bookmark value 40178 S1C00HYC00Driver not capable 40179 S1T00HYT00Timeout expired 40180 0800308003Connection not open 40181 25S0125S01Enlistment is not possible due to pending transaction 40182 25S0225S02Distributed Transaction Error 40183 0100001000An error has occurred during an attempt to access the log file, logging disabled. 40184 22003HY019Non-character data sent in pieces 40185 01S0201S02Packet size changed 40186 01S0201S02Cursor type changed 40187 01S0201S02Cursor concurrency changed 40188 0100001000Connected to backup server 40191 01S0201S02Login timeout changed 40200 0100001000SQL Debugging disabled 40500 Data Source Name 40501 Driver 40502 Server 40503 Login ID 40504 Password 40505 AppName 40506 WorkStation ID 40507 Language 40508 Database 40600 Unknown NetErr. 40601 Insufficient memory. 40602 Access denied. 40603 Connection is busy. 40604 Connection broken. 40605 Connection limit exceeded. 40606 Specified SQL server not found. 40607 The network has not been started. 40608 Insufficient network resources. 40609 Network is busy. 40610 Network access denied. 40611 General network error. Check your network documentation. 40612 Incorrect connection mode. 40613 Name not found in directory service. 40614 Invalid connection. 40615 Error reading or writing network data. 40616 Too many open file handles. 40617 SQL Server does not exist or access denied.